Top N/Sort Group Expert

This Expert appears when you choose the Top N/Sort Group Expert command from the Report menu.

Use the Top N/Sort Group Expert to identify "top" groups (the best sales representatives in a sales report, the biggest customers in an order report, the states with the most customers in a customer report, and so on).

Use the Top N/Sort Group Expert to sort all of the records in a report or just the top or bottom groups of records. Depending on which option you choose the Expert appears with different options.

Group/Sort

Use this list to choose one of the following sorting options for your Top group:

based on

This list displays a list of summary fields in your report. Select the field you want to select Top N or Bottom N values for from this list. When Sort All groups is selected, use the scroll box below the based on list to see the fields chosen for sorting.

where N is

Enter the number of Top N or Bottom N values (where N is the number of values) you want to select into this edit box.

include Others, with the name

Select this option if you want to include all fields that do not fit into your Top N or Bottom N selection under a specified group name. Enter the group name you want all fields that do not fit into your Top N or Bottom N selection to appear under.

Delete

Click this button to delete the selected summary field. This is only available when Sort All Groups is selected.

Ascending/Descending

Select the Ascending option to sort the fields in ascending (A to Z, 1 to 9) order.

Select the Descending option to sort the fields in descending (Z to A, 9 to 1) order.

Related topics

Sorting, Grouping, and Totaling



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com